SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511328 LIMIT 1 [ RunTime:0.000788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511328 [ RunTime:0.003525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668014,39461,41744,164215,33197,116711,99735,574785,654260,329144,564520,693864,36155,559982,351829,378550,935532,868416,967451,433602,920412,682478,871366,922095,216745,671850,89287,680150,743712,405109,518649,577066,541115,1005710,647037,428170,91165,346822,550005,1023052,359987,267199,182431,14522,213856,419104,862319,1036405,249128,591942,938806,858509,562769,241840,532093,47848,249897,163833,88900,755242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001279s ]