SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011007 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011007 [ RunTime:0.006002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310992,584318,224281,389608,233129,869444,551740,501545,447244,753801,927510,847865,322251,172948,578787,962825,593189,276449,762855,556132,310892,464453,965535,636124,705355,215085,818850,109131,390264,602880,364596,582821,247278,101734,197378,928690,850852,764995,581503,914608,368535,194828,598936,1000101,848752,307351,716922,924921,632238,706719,184759,815073,19073,186140,635232,917824,791421,809167,337508,165385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]