SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49143 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49143 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040426,686394,509234,583521,965845,418355,859045,482926,506846,163718,774942,472764,967799,409394,992611,293705,749609,278215,139767,381338,1002173,789158,195141,488835,748876,424921,735448,631186,1036728,747607,508961,816144,22726,402686,558542,703773,743797,977580,677465,555420,403574,73355,146612,911330,186849,950777,170479,1018800,929758,10314,1035950,586320,796143,338611,717167,182931,475968,436562,481156,623494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]