SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517920 LIMIT 1 [ RunTime:0.001253s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517920 [ RunTime:0.004097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965530,484903,621689,455574,10739,303722,561310,929650,906923,730977,748252,332865,108207,621807,1036135,612759,76062,1034411,504136,788554,866750,360288,1017651,406423,262555,438275,501147,972494,594417,751499,498394,130296,494748,104846,940543,327931,954566,439513,716909,528848,4641,14613,27879,795850,708726,117243,813844,1033164,223722,787183,797401,415396,398559,318500,480517,899534,177760,431424,906124,839343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]