SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264596 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264596 [ RunTime:0.002492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261427,1028864,792144,590939,954567,1039898,756708,254607,243664,890079,395577,373695,492544,637443,178010,734197,965077,689194,127780,672769,794944,965550,233954,725382,706348,352605,878076,243236,436904,149222,419921,488390,1048132,860279,717701,688788,832505,811589,457516,21121,360140,652513,323762,935833,174032,978826,549223,930604,157014,563699,303184,956898,268144,832033,305424,357483,371955,388873,560102,789661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]