SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323213 LIMIT 1 [ RunTime:0.001124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323213 [ RunTime:0.003770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982284,229422,820724,93722,720924,907190,210159,294014,776022,858646,896094,346599,387673,891541,610088,689858,783002,488699,901888,1046837,673696,758444,506010,289765,259533,911965,98059,484289,740928,547995,226779,740108,539965,777791,605631,217178,951522,508293,935035,163961,227161,199309,490871,417658,319310,340437,633696,247003,387160,347376,128523,220401,471076,1002838,809773,776803,819272,573335,268818,662243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]