SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580043 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580043 [ RunTime:0.005496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045750,971593,2475,777770,60376,76516,165001,570854,545972,1004761,913195,447524,744513,898439,259042,85258,116157,846105,467360,397262,572988,327753,916899,17949,252963,813341,928099,157080,62181,60931,966079,385870,619075,1036765,91886,465362,181351,460082,489767,758130,632203,90755,297477,776458,453444,756834,820474,84587,583650,965230,914780,589957,564918,357121,851456,104752,498739,979383,762230,54291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]