SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396545 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396545 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002236,198243,174670,486559,1042007,352013,702144,1004564,94095,332816,741749,558071,261334,1004978,23826,172389,447073,293734,449056,84372,786386,170843,571591,982585,562512,10010,321906,264689,31971,433367,876811,946233,302157,133835,1033380,934710,529059,286214,44599,184200,559950,109530,153044,395380,364473,622522,1012450,113770,1048471,945041,197393,879474,704348,276750,733076,734729,692952,819143,363595,106495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]