SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341145 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341145 [ RunTime:0.005501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355898,1037093,780777,371294,1047446,4867,347635,116851,156020,621091,708669,262047,936064,794131,325218,119206,406430,250568,371161,984562,932656,739313,1046923,407368,459745,773242,414984,113065,786875,31093,684611,160948,273299,716100,940205,201919,482961,184475,1033249,411434,313681,687779,1001301,272631,1019377,501481,810535,881640,79184,1032458,740400,90980,445849,666965,573502,863814,507927,745790,354824,590959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003078s ]