SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149871 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149871 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25820,17330,773147,807221,94235,323688,708879,497505,418457,402763,140838,697896,540987,289843,408895,86779,135880,561309,499204,488353,880814,949111,139791,253412,463092,259867,250788,749388,206836,144100,327614,740688,187819,762501,830132,681316,19980,335056,480714,858691,1040367,101058,725930,567056,783722,850172,465507,852699,744537,75813,569897,268678,570258,661027,989500,274822,182248,408849,341862,258354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001095s ]