SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512239 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512239 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040403,100696,444922,80768,1006810,372655,693557,153817,368328,1033904,632940,756962,454405,987008,183877,707997,244964,339925,898877,728408,204791,389928,681644,921279,930498,381829,256651,560963,1046782,208737,785204,87556,522672,615083,347494,320978,251427,763810,668212,179505,874845,534962,779917,263470,90486,932462,650209,1046262,887518,162329,815033,643621,813428,232914,974601,877449,585898,910785,1011059,617392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]