SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016973 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016973 [ RunTime:0.003560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340240,884523,385435,456281,410913,95203,835028,820873,481595,999634,478649,509399,555298,810868,498074,454094,331155,36867,778868,25200,275047,203953,288875,226424,1005156,95070,500707,482406,104264,247337,812064,791244,998040,912674,1020649,741374,223681,515013,151660,462291,42926,941842,120146,432540,1008320,754565,265090,543071,429749,397078,114006,563227,788404,1015729,610518,857911,896922,571276,468190,404124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]