SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027976 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027976 [ RunTime:0.003685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475032,662663,67401,990239,524080,185870,693213,335831,589209,532256,869042,640906,39982,569349,167689,44147,391167,885610,625450,374544,315423,529556,639869,1043716,983552,427551,1039404,930933,808193,29350,391490,198127,780729,277676,442716,546967,420759,314547,276975,226787,432769,281608,67560,236410,244092,520780,465949,421347,353281,769225,628261,202279,973668,467085,587678,101258,429809,70969,251874,828646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]