SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342140 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342140 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422044,384355,442204,82538,272402,69971,81142,447759,630950,128116,159379,384782,536390,166362,905384,134663,36179,716880,22100,349301,525118,575846,104266,313253,1005730,801623,965181,66218,268254,483349,252088,865611,996149,231912,985622,101383,116842,483851,787367,103578,228662,844576,893773,974775,499724,805731,968816,327885,43995,39453,182367,839348,834398,451775,192050,880070,824454,1026987,204195,359557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]