SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393991 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393991 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373307,730212,352180,136850,627210,101716,780094,426891,1041868,1014464,874900,793627,47970,1012551,71557,299207,324771,606865,314474,939963,166882,157979,799702,497266,413183,673709,207165,18901,186624,605086,20928,452358,38265,587101,277359,59154,861472,704548,670039,891197,697610,30037,2898,881126,580430,960933,926701,993521,240597,863393,547841,555925,434207,1003751,136437,1015742,999585,403773,988440,959124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]