SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150102 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150102 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284996,34520,633913,396040,480513,331738,564400,477438,1006723,586441,352772,233819,672308,490237,758879,224110,140877,982861,292743,791305,606733,976317,157408,895214,829131,531474,365115,415648,322709,815196,125329,50428,24572,364871,401145,90728,200001,345200,974421,467946,48977,53162,445729,789731,976145,838021,473547,621142,932515,331758,1014907,251471,10852,700182,425160,22542,918171,971341,763719,502352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]