SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002915s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501273 LIMIT 1 [ RunTime:0.001100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501273 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434105,391571,664521,171199,641510,150580,673455,665044,157727,154076,735344,182986,717695,853179,408372,568908,841012,254760,473209,620830,693795,621931,902212,178757,18668,551305,221923,293324,789144,103057,339037,756037,19700,1046019,659777,593856,601248,888142,287175,187521,873032,115596,787014,500576,339293,167695,141469,529306,622859,930278,980537,746892,800982,296292,475921,873033,886300,7916,320309,782751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001112s ]