SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354551 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354551 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501542,287104,500637,235492,656592,861339,936213,727524,944672,112293,563099,1013557,430991,296609,428940,639443,944510,60162,148066,329525,25278,553765,811482,248832,656626,198976,416037,142484,533319,985926,64075,1005213,1027084,220123,624944,812443,54123,174316,736678,183299,841004,623945,749368,843956,374200,995956,229647,460776,194636,991050,523939,425344,976280,400559,64237,588565,477319,956160,770749,1038659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]