SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670311 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670311 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843632,470974,509013,161240,362178,745261,437260,323123,312317,155150,113431,135238,524401,1043441,736775,780461,432932,856472,84751,403851,305456,787165,373873,268384,135088,324487,69821,689271,513368,418909,984225,88738,683750,266374,392884,923027,830141,587006,486228,654184,251720,879353,666549,289097,538113,861151,357067,153186,368381,967984,669352,242527,519250,52763,601747,563050,537941,697268,460468,913749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]