SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441938 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441938 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996290,404016,212123,719103,271719,542065,253809,799563,1029319,126276,463014,68101,469257,311328,942609,409851,400244,639174,807356,832442,655142,283086,473539,283505,531455,532123,553788,680189,5653,952225,373011,281794,16583,132421,534617,370579,863847,890524,55209,1040541,516331,1037529,290448,604340,137403,341478,192249,250679,825383,619111,131682,1040643,955321,620182,863669,403382,731747,160648,130026,109492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]