SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 277193 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 277193 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243011,119150,931257,587594,145064,693990,209675,775064,601813,383980,734913,641758,294844,572340,631591,889705,498595,984823,88246,375935,211615,972629,880491,14163,1042441,913269,31842,712098,361991,839378,384193,91513,27834,454316,946375,902620,821454,814729,627781,595904,1008832,862908,908190,199201,314664,927545,622861,408637,1043821,49053,908220,208667,1013039,885885,732879,73044,856936,613031,261154,34478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 277193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 277193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]