SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546694 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546694 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405342,221129,790473,426908,1026453,875090,626438,434420,182826,437641,834985,236807,756505,745880,540830,132661,226827,154625,182411,572355,471822,950477,771408,970383,93997,370493,559662,64340,129518,793149,689137,417803,399611,990881,1014892,599225,917399,314240,647200,162271,772074,8257,988256,70774,679996,277301,597084,709076,778307,444826,122954,336113,310179,464172,114678,387681,814085,932250,270558,419742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]