SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326480 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326480 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482631,312177,646568,988254,570054,636135,46787,445109,787591,682860,1039642,208024,98779,154469,674964,162733,546211,67089,402450,611255,247939,692738,299476,11680,316113,623540,831267,890230,973872,765781,566274,273268,689526,951839,795626,424730,619418,64155,65991,940223,42282,732694,720606,110315,285484,959546,304630,997977,889267,601949,1017518,270940,262045,661802,119275,8492,803615,370431,72241,82442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]