SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024571 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024571 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82184,167510,579165,266119,909260,31715,769894,352047,57319,416625,229391,407686,96115,894565,364787,489003,532307,207501,450902,255068,849144,48776,308276,890221,1030080,1007488,723500,742032,12680,566121,584386,786154,532583,658671,11990,962867,621636,409944,854014,922019,590001,195898,193573,1001347,244357,256032,651788,314999,143105,216991,553353,353388,686029,175087,244649,822426,527001,967014,906995,850933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]