SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579283 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579283 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688427,37204,107399,496255,102120,175467,238296,962820,1015782,251707,322624,70591,506734,904635,599274,923724,618419,576181,176932,805959,821243,438886,47141,762410,488918,243145,707076,621172,754878,266963,546852,484851,844479,984948,161863,506386,457621,976944,160067,183644,504415,33461,905174,164843,677561,363096,292654,850012,101319,710627,786241,212123,591349,814108,853447,572690,653042,253957,411753,306295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]