SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314923 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314923 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151889,1043025,25232,991799,935534,276311,920949,488218,60313,338188,52874,325964,684742,129513,357130,905511,609794,66393,363858,339482,648991,857203,276404,910817,26574,427488,511716,432905,150780,998833,867789,719123,798645,281558,763480,288086,338797,235137,696690,10184,577565,569052,457769,652468,50258,868769,297644,992641,224682,437967,200109,426459,366759,539736,959972,262013,65410,979866,368140,289846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000878s ]