SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536503 LIMIT 1 [ RunTime:0.000700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536503 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344712,975189,501936,938476,168057,320439,9894,909067,108252,551208,691049,299554,859588,243166,640952,445608,185562,357764,549224,476176,198336,676892,411784,498169,302676,390490,961249,933376,184317,254989,393537,318275,951815,280252,48960,809592,708505,511546,486331,49026,371999,568783,210063,851635,342510,717691,78,366080,923581,579641,1032351,973219,367444,571492,284631,137821,140316,530355,568013,368263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]