SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495313 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495313 [ RunTime:0.002727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340985,800675,150686,961633,170174,595519,962550,602230,201372,277279,73468,751877,1006753,823338,933896,196819,149854,187835,972102,281093,335572,527899,936297,513475,885185,448766,20078,771453,616639,260517,400913,175051,1048871,375627,64038,182769,177136,1004166,625257,1016597,326476,1022201,629507,89483,676036,443617,367748,301079,207044,181581,233075,362009,213886,281241,892700,475425,412544,369517,827864,535815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]