SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436341 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436341 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317054,504549,870016,195048,214664,635622,378624,710459,102339,517249,234373,42336,769039,809013,774598,277814,468063,257365,693936,769771,477273,436852,773107,194464,840596,265296,471797,672317,982640,296202,729266,928912,368765,331932,762041,168086,832645,316511,115989,252329,777613,691797,40893,631620,783154,1046658,658545,463802,643067,450711,886357,904021,541158,1037268,273000,231178,733155,777220,975053,405604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]