SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349413 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349413 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638696,613685,21119,282948,580276,945880,199931,13514,594328,641639,1017756,889775,262090,691612,756818,551382,743969,558844,403587,297225,999047,365407,445093,217860,467914,36268,955245,939893,372762,810652,378059,510607,688413,27630,1037366,576251,532819,655852,366571,983096,238970,111531,734993,580929,154462,253496,321385,628772,958394,72710,470066,46779,124699,731685,452870,26457,483436,948490,16101,549365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]