SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024724 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024724 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188071,892141,706839,298141,848211,162366,1013559,242031,863855,964668,1003313,429159,758810,488708,673228,907301,607222,90935,393269,969487,913555,290176,474638,961943,839954,558412,213684,138256,614648,370378,818655,723482,308338,521840,747579,1001118,153282,961914,628816,811197,468520,957141,450500,417035,625153,519412,283493,150297,82117,732839,187527,938461,539873,79447,946350,394477,320537,630790,523594,529279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]