SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508554 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508554 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630828,921609,865098,384088,134899,332436,831283,37526,220839,86500,129320,703261,902437,823162,794357,464370,1039044,113374,887332,177927,125252,1010139,58043,117749,1009634,392882,220926,191226,490444,902086,684919,729687,1031386,505135,713525,361404,162359,443009,167347,550150,501176,96112,1034130,120546,757556,322541,805024,950822,788347,1005956,605967,554605,750573,905493,1033374,954863,484087,1040936,634653,863782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]