SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285006 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285006 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503305,550016,379297,886785,117176,797158,27246,236777,1030455,773136,890507,806892,707393,965834,72183,770915,460936,462679,617588,781402,918102,544806,1021438,24561,507529,54478,673599,679077,478565,591851,916976,766344,125945,223760,355554,5234,932923,296782,864191,569280,740454,169452,136574,870079,22027,297158,929492,284414,449748,905658,996258,211765,779785,577159,527175,374237,501664,383520,1016478,434093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]