SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497912 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497912 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329680,999468,878230,209667,658655,167,607743,558698,885784,543727,520646,829284,147219,88347,369835,129462,75739,715597,971293,498294,890283,928110,832566,224203,693717,21326,68309,15743,415668,305151,461425,496159,1037159,949757,634705,256685,109051,291925,40957,350153,55386,136193,6560,218926,103060,584967,718176,775570,860977,437020,263741,229430,673517,146899,707751,1036154,862957,943594,265955,826071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]