SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804504 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804504 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555078,284347,643940,812811,946397,584240,110433,550705,536251,458011,1028278,514818,804908,492307,760948,67638,816758,912120,83867,75987,831544,450788,489503,268954,288559,613805,855497,1037890,868885,427203,649018,800384,1037170,1037719,588948,240237,168481,1039113,91489,892604,517647,893570,942920,449783,365267,867923,283742,13151,723327,314120,273536,81599,436713,340148,982202,1018234,81803,857602,1001391,316750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]