SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283511 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283511 [ RunTime:0.004540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841158,576670,151880,629750,733942,899189,177881,974788,141470,326549,13311,1024778,184386,981772,917724,355318,260641,436854,696547,823260,555455,250004,153114,500688,161293,249904,712029,276565,288388,467422,1026689,82635,184450,45492,58419,804177,810087,50067,573030,10520,60278,484482,326722,88846,446163,176172,543015,9700,937588,181935,83669,1038039,618925,92031,729176,552881,577518,173246,697478,642254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]