SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439252 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439252 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907854,83793,547606,902766,670639,741514,335027,528208,880459,956984,186523,369062,53871,519920,547735,137372,585918,633909,744202,515116,63877,508254,612538,132879,331814,207112,521353,900639,56134,923934,611717,245656,808243,808808,970226,751545,126525,577637,427615,10078,566531,410146,635699,249362,529764,318049,344697,1034748,356903,721167,611803,33161,558865,443539,434895,607403,145933,932820,484546,483458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]