SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020960 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020960 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269643,840637,428464,811903,399711,988996,940265,650243,872671,296682,456935,454407,521773,1202,58394,350105,368043,6151,483751,329700,666688,70339,484385,142919,921371,674200,943799,152725,353593,953162,836730,288457,986422,317211,640768,581490,889427,582123,723585,342476,688910,158760,285153,996988,578342,214162,836541,1045684,540472,94052,554485,393192,587258,509709,57901,588259,455112,1043934,273821,439371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]