SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804093 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804093 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339465,326246,331486,457257,1033558,352954,507818,673626,1008805,418679,144792,34752,88392,761823,372730,81461,264709,597342,681531,667901,151601,77939,180598,113293,382276,194390,498812,383363,103118,811924,965949,778837,586979,751529,290765,318587,116284,869932,1023077,1000389,991052,605087,404838,136794,136199,510503,807175,118328,374491,306062,10441,228790,1015472,940299,833916,326000,307088,550712,210937,177378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]