SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391995 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391995 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571609,160759,186966,895900,696374,174871,119194,210966,557650,112154,758563,845146,914402,607658,917520,69157,403053,892965,271008,605111,383211,566710,189582,381529,506824,261158,987136,742725,121398,993940,246033,331959,697576,783335,894302,614414,587587,837859,985654,945585,207682,551250,125587,550588,12616,574631,365203,454327,401100,206481,499113,383374,996004,79761,186430,842493,639334,151844,120920,355919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000961s ]