SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555412 LIMIT 1 [ RunTime:0.002910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555412 [ RunTime:0.003203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128572,572902,737518,370053,661438,397604,942692,687358,232727,116720,917109,1027119,58167,288885,261611,22174,459861,789580,98609,598578,613408,648393,472398,882132,408194,149581,769553,291298,857621,827680,856794,179566,148395,75302,476284,509874,900673,147396,285283,191652,733729,890435,235738,201062,282447,315630,726493,994742,188065,156002,847385,609516,961740,736260,392245,149624,784823,513143,200080,208764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]