SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561907 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561907 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400914,778457,583163,1016669,757626,202097,712823,914967,843040,854947,1016054,686966,1012041,866656,967495,544929,266706,375661,230468,367905,203939,796007,334798,589259,353314,624820,31850,169650,307433,971593,146871,643470,419043,727478,124429,703211,507423,1014332,449437,386871,731491,838647,213747,465118,326474,541138,615513,188270,774159,789235,325178,958205,838801,681961,296356,608877,489802,904989,18441,783970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]