SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395282 LIMIT 1 [ RunTime:0.001139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395282 [ RunTime:0.001280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564053,99055,107668,190109,793939,940990,590082,650869,887272,817490,729027,330781,944866,469864,115829,610015,59629,1046873,731710,700106,711610,513941,978459,633120,921260,242984,1045643,1041512,458399,108474,774593,297380,517043,366146,495468,880395,775130,750505,329517,745852,481493,542059,93962,786001,175670,187882,79441,396517,398709,270086,615153,488169,937098,50595,998206,1019683,607407,435461,982985,220229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]