SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345714 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345714 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005606,658614,2294,1037741,954921,458789,678509,938493,852923,118740,941522,367060,189275,410383,442879,440058,207516,594164,193835,269694,104388,482055,967723,623324,426402,815286,612500,137316,69462,371580,128219,323476,325547,703238,861606,720094,935565,174489,884117,747150,125038,348818,26259,320196,1020114,23320,456182,243118,863844,116668,259056,1037597,355260,109674,755695,451912,935543,760578,671190,727783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]