SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50387 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50387 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519137,254418,624514,208340,660765,147280,691238,622767,876808,217698,405204,46791,846652,1045614,974938,1022000,596220,988681,675282,290592,493412,930179,537457,310379,695291,530548,538591,8236,237668,686683,94182,757748,496525,60486,553168,824403,345790,197822,425881,626630,745300,194058,484880,204524,185047,320062,24752,977223,12408,143270,326275,334273,1022705,136305,1047434,976714,194337,411776,405445,167385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]