SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343903 LIMIT 1 [ RunTime:0.002836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343903 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845831,94014,48438,486664,996666,973564,753488,906194,598747,899385,299842,42315,373252,71551,569763,448987,607966,479281,173435,690443,991730,264482,337739,130290,263342,14093,708852,790156,785071,70591,129702,51987,504247,636308,774183,489479,711686,339984,519066,202581,253991,239775,705869,364242,352767,392851,565321,664969,233045,218775,473321,719441,276913,955196,524754,1009545,637281,25599,742363,656744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]