SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567241 LIMIT 1 [ RunTime:0.000700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567241 [ RunTime:0.006715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036402,524192,556972,690701,366225,862551,372574,111245,117842,45445,390486,965382,703388,813035,1009644,547104,832036,304221,833321,1041271,894973,127681,633277,404472,615801,1030097,438067,118507,1045538,5179,540879,1038763,499386,341355,730226,1023101,157716,572145,431816,471471,129310,1008617,5423,890985,144691,954267,686805,821943,171979,346817,934276,276535,635303,485433,756402,453062,125663,793351,918614,923593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]