SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028067 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028067 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264798,475294,387252,215389,444348,953804,637387,633530,535892,385438,600710,377116,43351,778174,672744,189574,433202,706629,651063,381431,822759,1017682,157908,22983,475646,452991,156907,836118,77797,617056,902719,928285,605347,544392,438938,675855,430715,158447,741966,932344,300057,487893,549971,760885,642078,1028646,266457,798180,447294,651016,1005971,253555,1022152,810241,235830,78055,277100,109023,179154,1045429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]