SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 676183 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 676183 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012071,389474,767879,756178,95409,689072,417627,538232,361565,886241,705429,1003983,229082,291456,638100,535913,858492,241467,462131,280292,421449,867132,162405,268539,381413,894644,761188,671749,797565,871195,764306,670486,455751,687593,257403,730955,676850,551099,762327,159596,530744,40976,157130,493628,297102,503640,932362,855285,159739,181096,1044918,742284,841666,839331,802423,519404,746543,790158,719407,561007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 676183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 676183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001040s ]