SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 665458 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 665458 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712961,222594,7705,918744,706709,730248,797817,530279,655430,334877,824666,453963,42564,541807,930111,844454,962088,255781,440882,198303,590055,812601,359460,613445,434583,949807,747525,793007,876445,716644,112851,680585,1029202,339981,559081,514339,186204,412974,49978,457453,127281,231095,415333,636123,28173,903929,480651,496140,954828,1022885,970639,200998,994556,479519,204385,967180,261264,547460,880652,352059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 665458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 665458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001431s ]