SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543893 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543893 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564065,554014,427701,631800,208703,979786,606618,4795,828548,433010,156705,940915,956253,771415,759799,545727,90726,1033860,908650,429609,361381,595182,877946,409685,907956,764466,892259,798965,184082,566009,136338,12598,227239,147960,431937,231089,602649,654442,437656,559446,266285,105716,669292,388612,226115,351777,785994,774271,815751,608482,930400,883829,315215,242323,128571,703204,56264,43228,817550,36993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]