SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354714 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354714 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413483,77391,980749,527242,891010,874970,740970,178086,956218,762609,1031144,749434,25541,948484,40762,119484,609155,490525,739766,612637,133706,445376,445967,781727,44854,800641,189917,560844,970010,19406,27389,281545,207195,642979,1026630,882824,832101,188967,933025,638082,1021206,726222,312651,167837,556369,219972,438912,944827,127002,961163,662868,1710,372847,605741,533127,581586,347539,649312,74618,309308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]