SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 964318 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 964318 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301103,512476,129608,927047,142204,827239,696835,614117,128792,241993,846183,39346,363152,974898,936242,516767,521008,183779,672788,796619,371881,364252,583608,397634,402492,596105,903098,272831,793935,472549,172694,374350,228318,776184,937700,808122,867275,344361,342163,934360,651709,306237,518815,114395,987658,380269,25444,382969,878778,446781,168012,737118,987275,260362,819739,409469,255364,121896,142450,338387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 964318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 964318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]