SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451904 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451904 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39620,195314,360047,871713,707354,525837,410900,741427,797107,551724,79159,337459,696570,320954,232849,26444,19988,76662,271317,223243,156808,33785,612508,487594,457612,564803,200420,44898,1027421,609996,957364,76432,545947,138473,401881,981514,859548,451297,581789,338319,434334,591386,264289,69860,499529,650343,1000469,54327,618009,64213,1009953,771802,151485,960167,784256,45988,654785,144387,135075,37796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]