SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328011 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328011 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285714,433870,731120,778531,808548,841208,104539,252196,146292,244553,12873,486796,687151,417095,482084,769396,459335,624967,485457,240825,149631,331620,1029680,613690,1046803,826379,876846,740459,705924,748817,712575,82547,698546,421501,685059,658440,345129,765159,715746,352931,477162,105762,492811,222473,659103,353778,446110,212830,495059,973519,423306,892672,257438,944563,463144,771750,149767,831351,632975,855823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]