SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045998 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045998 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798704,354432,545942,267084,616623,386578,29823,440133,754632,814672,818932,179124,596714,36151,213436,883159,907613,260375,687018,607819,626080,981633,230270,864514,11613,928641,557686,146189,161981,785714,359726,596279,465680,538500,964256,984333,913336,706241,265125,433920,36864,693510,65771,582847,646582,847173,997153,249368,77924,750522,56066,509126,978413,477581,730747,944263,181292,846493,354270,701455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]