SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286654 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286654 [ RunTime:0.003786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281665,147761,472435,957140,799992,787642,831056,518023,108661,606970,490450,974785,731539,1026562,788078,180811,636207,958693,717247,234014,587846,850332,653638,804394,197508,792768,814251,840750,621362,451103,447901,392598,1011422,713759,205513,556883,453934,122979,393343,372101,22145,873092,756984,678577,323008,675339,171459,647170,901501,730995,265143,205268,223451,71884,36806,377314,255224,154124,840652,706663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]