SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504910 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504910 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978229,254411,371140,295198,752867,130658,924455,776275,848813,870429,651076,390884,695146,738472,911651,12784,124117,508870,17296,921329,980589,865174,303323,263684,997598,490787,725681,982403,568274,941354,1031836,550673,145412,827977,250589,893019,619509,69340,145419,197028,351437,815160,1038310,36693,366302,863912,294184,452445,773322,908804,788249,760719,621983,323189,517041,560780,157617,471057,308416,35902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]