SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001975s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540663 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540663 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812753,314303,805122,692087,805267,515322,21443,110148,170173,1004199,294616,629795,912535,572290,75596,198252,252705,377290,915421,325777,181076,390720,305487,65380,476186,758639,949924,209645,475229,230923,205795,855547,267007,993217,1043719,798029,156389,596679,910626,130903,148976,849280,147443,751746,955222,243849,822502,244014,814673,644661,441966,574695,288192,187373,879296,488860,585790,1038104,898851,512260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]