SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405253 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405253 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227854,809880,154354,249842,216539,533723,632198,605223,372692,429768,648033,846007,608102,368894,374359,650240,702472,506133,951298,843977,302306,305734,206594,488005,996643,106900,114312,524266,733726,145179,186771,397610,566420,397775,98476,184107,372844,690033,223108,71808,259535,736323,518700,713338,228342,82241,837820,295809,881711,96913,859584,57421,119044,101120,908712,785254,664556,850077,360049,364645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]