SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392001 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392001 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174110,205187,791377,1021849,395521,43908,861885,547164,134502,420135,1039851,448333,586014,758789,313237,1037061,164944,354739,885011,596584,77758,174569,665612,110969,859393,943201,405162,816816,429076,1012856,720523,933685,953646,102718,873922,175682,358354,392416,751592,30046,715128,521183,691511,215792,512093,600774,1044087,71985,992638,22064,968426,751316,997914,108578,578294,626234,208567,601898,440063,89091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]