SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110009 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110009 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92221,112971,421862,921663,158375,706924,31814,414521,81085,910272,1046940,875524,984257,51984,872416,824588,839741,568031,507397,639884,338170,672627,1042367,217774,569155,1011221,558158,376302,521017,755456,572772,146927,1434,1023275,930862,701628,486134,9655,442862,957362,687366,598671,782010,167011,830685,1022586,995984,569890,571,881087,1008435,955621,810870,828688,443668,604379,284641,654998,400764,889336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]