SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586975 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586975 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004171,52205,311812,258318,818923,652953,121934,661239,728483,321969,928747,985069,210691,660349,745884,175346,142011,66214,995184,358772,790075,915479,834768,22815,641402,293865,925055,608912,248112,983204,660835,908216,274979,158523,264497,1031735,817932,411725,491513,747198,741400,370245,888639,77266,717886,942517,524504,626736,235603,832465,242839,515944,820210,337741,39423,68556,645622,817528,1011755,588326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]