SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020582 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020582 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979610,539390,976278,522076,424128,548460,1024522,543522,657105,636055,119598,358981,526106,48595,608851,969789,704877,631063,862304,299979,753932,357257,784383,42601,638079,562202,814087,690942,33049,429553,903234,818244,549606,474459,615052,889622,856782,237507,247211,313017,862161,3852,943175,410449,285698,192279,1011994,740971,662655,671674,440761,532359,840131,472026,551978,593240,376658,964376,230287,623068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]