SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409710 LIMIT 1 [ RunTime:0.000892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409710 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419659,294410,589020,740326,765184,137531,118370,351830,415323,828505,393177,745031,522144,1027459,798279,83320,136017,513093,608491,568641,192115,216240,988903,256979,337125,57363,428054,426749,575645,1014282,1017765,518711,659398,603270,313525,95659,556170,835529,109770,953235,886874,63927,105900,267363,1027846,99788,793862,464583,44507,685820,91241,994661,537260,1016800,201603,728987,436208,624826,357661,457416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001049s ]