SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010668 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010668 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925677,267011,143592,729546,321011,702951,311888,883222,598167,988127,317042,729107,281020,723060,784331,997124,969275,808045,105398,1003100,60472,107900,1022300,210902,879003,559731,510521,188132,94408,725607,1045758,199856,559173,1035779,719064,842080,553602,98226,680168,862091,612885,832535,262971,276439,350642,483863,561440,39266,105410,606267,670488,1014066,128281,373859,933748,272560,799636,426093,1043282,894932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001621s ]